package com.erp.erp_entitys.ProducFjInfo;

import java.util.ArrayList;
import java.util.List;

public class ProducFjInfoExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    private Boolean forUpdate;

    public ProducFjInfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setForUpdate(Boolean forUpdate) {
        this.forUpdate = forUpdate;
    }

    public Boolean getForUpdate() {
        return forUpdate;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCodeIsNull() {
            addCriterion("code is null");
            return (Criteria) this;
        }

        public Criteria andCodeIsNotNull() {
            addCriterion("code is not null");
            return (Criteria) this;
        }

        public Criteria andCodeEqualTo(String value) {
            addCriterion("code =", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotEqualTo(String value) {
            addCriterion("code <>", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThan(String value) {
            addCriterion("code >", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThanOrEqualTo(String value) {
            addCriterion("code >=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThan(String value) {
            addCriterion("code <", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThanOrEqualTo(String value) {
            addCriterion("code <=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLike(String value) {
            addCriterion("code like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotLike(String value) {
            addCriterion("code not like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeIn(List<String> values) {
            addCriterion("code in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotIn(List<String> values) {
            addCriterion("code not in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeBetween(String value1, String value2) {
            addCriterion("code between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotBetween(String value1, String value2) {
            addCriterion("code not between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andGeIsNull() {
            addCriterion("ge is null");
            return (Criteria) this;
        }

        public Criteria andGeIsNotNull() {
            addCriterion("ge is not null");
            return (Criteria) this;
        }

        public Criteria andGeEqualTo(String value) {
            addCriterion("ge =", value, "ge");
            return (Criteria) this;
        }

        public Criteria andGeNotEqualTo(String value) {
            addCriterion("ge <>", value, "ge");
            return (Criteria) this;
        }

        public Criteria andGeGreaterThan(String value) {
            addCriterion("ge >", value, "ge");
            return (Criteria) this;
        }

        public Criteria andGeGreaterThanOrEqualTo(String value) {
            addCriterion("ge >=", value, "ge");
            return (Criteria) this;
        }

        public Criteria andGeLessThan(String value) {
            addCriterion("ge <", value, "ge");
            return (Criteria) this;
        }

        public Criteria andGeLessThanOrEqualTo(String value) {
            addCriterion("ge <=", value, "ge");
            return (Criteria) this;
        }

        public Criteria andGeLike(String value) {
            addCriterion("ge like", value, "ge");
            return (Criteria) this;
        }

        public Criteria andGeNotLike(String value) {
            addCriterion("ge not like", value, "ge");
            return (Criteria) this;
        }

        public Criteria andGeIn(List<String> values) {
            addCriterion("ge in", values, "ge");
            return (Criteria) this;
        }

        public Criteria andGeNotIn(List<String> values) {
            addCriterion("ge not in", values, "ge");
            return (Criteria) this;
        }

        public Criteria andGeBetween(String value1, String value2) {
            addCriterion("ge between", value1, value2, "ge");
            return (Criteria) this;
        }

        public Criteria andGeNotBetween(String value1, String value2) {
            addCriterion("ge not between", value1, value2, "ge");
            return (Criteria) this;
        }

        public Criteria andChinaRemarkIsNull() {
            addCriterion("china_remark is null");
            return (Criteria) this;
        }

        public Criteria andChinaRemarkIsNotNull() {
            addCriterion("china_remark is not null");
            return (Criteria) this;
        }

        public Criteria andChinaRemarkEqualTo(String value) {
            addCriterion("china_remark =", value, "chinaRemark");
            return (Criteria) this;
        }

        public Criteria andChinaRemarkNotEqualTo(String value) {
            addCriterion("china_remark <>", value, "chinaRemark");
            return (Criteria) this;
        }

        public Criteria andChinaRemarkGreaterThan(String value) {
            addCriterion("china_remark >", value, "chinaRemark");
            return (Criteria) this;
        }

        public Criteria andChinaRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("china_remark >=", value, "chinaRemark");
            return (Criteria) this;
        }

        public Criteria andChinaRemarkLessThan(String value) {
            addCriterion("china_remark <", value, "chinaRemark");
            return (Criteria) this;
        }

        public Criteria andChinaRemarkLessThanOrEqualTo(String value) {
            addCriterion("china_remark <=", value, "chinaRemark");
            return (Criteria) this;
        }

        public Criteria andChinaRemarkLike(String value) {
            addCriterion("china_remark like", value, "chinaRemark");
            return (Criteria) this;
        }

        public Criteria andChinaRemarkNotLike(String value) {
            addCriterion("china_remark not like", value, "chinaRemark");
            return (Criteria) this;
        }

        public Criteria andChinaRemarkIn(List<String> values) {
            addCriterion("china_remark in", values, "chinaRemark");
            return (Criteria) this;
        }

        public Criteria andChinaRemarkNotIn(List<String> values) {
            addCriterion("china_remark not in", values, "chinaRemark");
            return (Criteria) this;
        }

        public Criteria andChinaRemarkBetween(String value1, String value2) {
            addCriterion("china_remark between", value1, value2, "chinaRemark");
            return (Criteria) this;
        }

        public Criteria andChinaRemarkNotBetween(String value1, String value2) {
            addCriterion("china_remark not between", value1, value2, "chinaRemark");
            return (Criteria) this;
        }

        public Criteria andEnglishRemarkIsNull() {
            addCriterion("english_remark is null");
            return (Criteria) this;
        }

        public Criteria andEnglishRemarkIsNotNull() {
            addCriterion("english_remark is not null");
            return (Criteria) this;
        }

        public Criteria andEnglishRemarkEqualTo(String value) {
            addCriterion("english_remark =", value, "englishRemark");
            return (Criteria) this;
        }

        public Criteria andEnglishRemarkNotEqualTo(String value) {
            addCriterion("english_remark <>", value, "englishRemark");
            return (Criteria) this;
        }

        public Criteria andEnglishRemarkGreaterThan(String value) {
            addCriterion("english_remark >", value, "englishRemark");
            return (Criteria) this;
        }

        public Criteria andEnglishRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("english_remark >=", value, "englishRemark");
            return (Criteria) this;
        }

        public Criteria andEnglishRemarkLessThan(String value) {
            addCriterion("english_remark <", value, "englishRemark");
            return (Criteria) this;
        }

        public Criteria andEnglishRemarkLessThanOrEqualTo(String value) {
            addCriterion("english_remark <=", value, "englishRemark");
            return (Criteria) this;
        }

        public Criteria andEnglishRemarkLike(String value) {
            addCriterion("english_remark like", value, "englishRemark");
            return (Criteria) this;
        }

        public Criteria andEnglishRemarkNotLike(String value) {
            addCriterion("english_remark not like", value, "englishRemark");
            return (Criteria) this;
        }

        public Criteria andEnglishRemarkIn(List<String> values) {
            addCriterion("english_remark in", values, "englishRemark");
            return (Criteria) this;
        }

        public Criteria andEnglishRemarkNotIn(List<String> values) {
            addCriterion("english_remark not in", values, "englishRemark");
            return (Criteria) this;
        }

        public Criteria andEnglishRemarkBetween(String value1, String value2) {
            addCriterion("english_remark between", value1, value2, "englishRemark");
            return (Criteria) this;
        }

        public Criteria andEnglishRemarkNotBetween(String value1, String value2) {
            addCriterion("english_remark not between", value1, value2, "englishRemark");
            return (Criteria) this;
        }

        public Criteria andBzsmIsNull() {
            addCriterion("bzsm is null");
            return (Criteria) this;
        }

        public Criteria andBzsmIsNotNull() {
            addCriterion("bzsm is not null");
            return (Criteria) this;
        }

        public Criteria andBzsmEqualTo(String value) {
            addCriterion("bzsm =", value, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmNotEqualTo(String value) {
            addCriterion("bzsm <>", value, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmGreaterThan(String value) {
            addCriterion("bzsm >", value, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmGreaterThanOrEqualTo(String value) {
            addCriterion("bzsm >=", value, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmLessThan(String value) {
            addCriterion("bzsm <", value, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmLessThanOrEqualTo(String value) {
            addCriterion("bzsm <=", value, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmLike(String value) {
            addCriterion("bzsm like", value, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmNotLike(String value) {
            addCriterion("bzsm not like", value, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmIn(List<String> values) {
            addCriterion("bzsm in", values, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmNotIn(List<String> values) {
            addCriterion("bzsm not in", values, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmBetween(String value1, String value2) {
            addCriterion("bzsm between", value1, value2, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmNotBetween(String value1, String value2) {
            addCriterion("bzsm not between", value1, value2, "bzsm");
            return (Criteria) this;
        }

        public Criteria andCpjzIsNull() {
            addCriterion("cpjz is null");
            return (Criteria) this;
        }

        public Criteria andCpjzIsNotNull() {
            addCriterion("cpjz is not null");
            return (Criteria) this;
        }

        public Criteria andCpjzEqualTo(String value) {
            addCriterion("cpjz =", value, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzNotEqualTo(String value) {
            addCriterion("cpjz <>", value, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzGreaterThan(String value) {
            addCriterion("cpjz >", value, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzGreaterThanOrEqualTo(String value) {
            addCriterion("cpjz >=", value, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzLessThan(String value) {
            addCriterion("cpjz <", value, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzLessThanOrEqualTo(String value) {
            addCriterion("cpjz <=", value, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzLike(String value) {
            addCriterion("cpjz like", value, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzNotLike(String value) {
            addCriterion("cpjz not like", value, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzIn(List<String> values) {
            addCriterion("cpjz in", values, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzNotIn(List<String> values) {
            addCriterion("cpjz not in", values, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzBetween(String value1, String value2) {
            addCriterion("cpjz between", value1, value2, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzNotBetween(String value1, String value2) {
            addCriterion("cpjz not between", value1, value2, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpmzIsNull() {
            addCriterion("cpmz is null");
            return (Criteria) this;
        }

        public Criteria andCpmzIsNotNull() {
            addCriterion("cpmz is not null");
            return (Criteria) this;
        }

        public Criteria andCpmzEqualTo(String value) {
            addCriterion("cpmz =", value, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzNotEqualTo(String value) {
            addCriterion("cpmz <>", value, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzGreaterThan(String value) {
            addCriterion("cpmz >", value, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzGreaterThanOrEqualTo(String value) {
            addCriterion("cpmz >=", value, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzLessThan(String value) {
            addCriterion("cpmz <", value, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzLessThanOrEqualTo(String value) {
            addCriterion("cpmz <=", value, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzLike(String value) {
            addCriterion("cpmz like", value, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzNotLike(String value) {
            addCriterion("cpmz not like", value, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzIn(List<String> values) {
            addCriterion("cpmz in", values, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzNotIn(List<String> values) {
            addCriterion("cpmz not in", values, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzBetween(String value1, String value2) {
            addCriterion("cpmz between", value1, value2, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzNotBetween(String value1, String value2) {
            addCriterion("cpmz not between", value1, value2, "cpmz");
            return (Criteria) this;
        }

        public Criteria andColourIsNull() {
            addCriterion("colour is null");
            return (Criteria) this;
        }

        public Criteria andColourIsNotNull() {
            addCriterion("colour is not null");
            return (Criteria) this;
        }

        public Criteria andColourEqualTo(String value) {
            addCriterion("colour =", value, "colour");
            return (Criteria) this;
        }

        public Criteria andColourNotEqualTo(String value) {
            addCriterion("colour <>", value, "colour");
            return (Criteria) this;
        }

        public Criteria andColourGreaterThan(String value) {
            addCriterion("colour >", value, "colour");
            return (Criteria) this;
        }

        public Criteria andColourGreaterThanOrEqualTo(String value) {
            addCriterion("colour >=", value, "colour");
            return (Criteria) this;
        }

        public Criteria andColourLessThan(String value) {
            addCriterion("colour <", value, "colour");
            return (Criteria) this;
        }

        public Criteria andColourLessThanOrEqualTo(String value) {
            addCriterion("colour <=", value, "colour");
            return (Criteria) this;
        }

        public Criteria andColourLike(String value) {
            addCriterion("colour like", value, "colour");
            return (Criteria) this;
        }

        public Criteria andColourNotLike(String value) {
            addCriterion("colour not like", value, "colour");
            return (Criteria) this;
        }

        public Criteria andColourIn(List<String> values) {
            addCriterion("colour in", values, "colour");
            return (Criteria) this;
        }

        public Criteria andColourNotIn(List<String> values) {
            addCriterion("colour not in", values, "colour");
            return (Criteria) this;
        }

        public Criteria andColourBetween(String value1, String value2) {
            addCriterion("colour between", value1, value2, "colour");
            return (Criteria) this;
        }

        public Criteria andColourNotBetween(String value1, String value2) {
            addCriterion("colour not between", value1, value2, "colour");
            return (Criteria) this;
        }

        public Criteria andDwIsNull() {
            addCriterion("dw is null");
            return (Criteria) this;
        }

        public Criteria andDwIsNotNull() {
            addCriterion("dw is not null");
            return (Criteria) this;
        }

        public Criteria andDwEqualTo(String value) {
            addCriterion("dw =", value, "dw");
            return (Criteria) this;
        }

        public Criteria andDwNotEqualTo(String value) {
            addCriterion("dw <>", value, "dw");
            return (Criteria) this;
        }

        public Criteria andDwGreaterThan(String value) {
            addCriterion("dw >", value, "dw");
            return (Criteria) this;
        }

        public Criteria andDwGreaterThanOrEqualTo(String value) {
            addCriterion("dw >=", value, "dw");
            return (Criteria) this;
        }

        public Criteria andDwLessThan(String value) {
            addCriterion("dw <", value, "dw");
            return (Criteria) this;
        }

        public Criteria andDwLessThanOrEqualTo(String value) {
            addCriterion("dw <=", value, "dw");
            return (Criteria) this;
        }

        public Criteria andDwLike(String value) {
            addCriterion("dw like", value, "dw");
            return (Criteria) this;
        }

        public Criteria andDwNotLike(String value) {
            addCriterion("dw not like", value, "dw");
            return (Criteria) this;
        }

        public Criteria andDwIn(List<String> values) {
            addCriterion("dw in", values, "dw");
            return (Criteria) this;
        }

        public Criteria andDwNotIn(List<String> values) {
            addCriterion("dw not in", values, "dw");
            return (Criteria) this;
        }

        public Criteria andDwBetween(String value1, String value2) {
            addCriterion("dw between", value1, value2, "dw");
            return (Criteria) this;
        }

        public Criteria andDwNotBetween(String value1, String value2) {
            addCriterion("dw not between", value1, value2, "dw");
            return (Criteria) this;
        }

        public Criteria andCgbzIsNull() {
            addCriterion("cgbz is null");
            return (Criteria) this;
        }

        public Criteria andCgbzIsNotNull() {
            addCriterion("cgbz is not null");
            return (Criteria) this;
        }

        public Criteria andCgbzEqualTo(String value) {
            addCriterion("cgbz =", value, "cgbz");
            return (Criteria) this;
        }

        public Criteria andCgbzNotEqualTo(String value) {
            addCriterion("cgbz <>", value, "cgbz");
            return (Criteria) this;
        }

        public Criteria andCgbzGreaterThan(String value) {
            addCriterion("cgbz >", value, "cgbz");
            return (Criteria) this;
        }

        public Criteria andCgbzGreaterThanOrEqualTo(String value) {
            addCriterion("cgbz >=", value, "cgbz");
            return (Criteria) this;
        }

        public Criteria andCgbzLessThan(String value) {
            addCriterion("cgbz <", value, "cgbz");
            return (Criteria) this;
        }

        public Criteria andCgbzLessThanOrEqualTo(String value) {
            addCriterion("cgbz <=", value, "cgbz");
            return (Criteria) this;
        }

        public Criteria andCgbzLike(String value) {
            addCriterion("cgbz like", value, "cgbz");
            return (Criteria) this;
        }

        public Criteria andCgbzNotLike(String value) {
            addCriterion("cgbz not like", value, "cgbz");
            return (Criteria) this;
        }

        public Criteria andCgbzIn(List<String> values) {
            addCriterion("cgbz in", values, "cgbz");
            return (Criteria) this;
        }

        public Criteria andCgbzNotIn(List<String> values) {
            addCriterion("cgbz not in", values, "cgbz");
            return (Criteria) this;
        }

        public Criteria andCgbzBetween(String value1, String value2) {
            addCriterion("cgbz between", value1, value2, "cgbz");
            return (Criteria) this;
        }

        public Criteria andCgbzNotBetween(String value1, String value2) {
            addCriterion("cgbz not between", value1, value2, "cgbz");
            return (Criteria) this;
        }

        public Criteria andCgcbIsNull() {
            addCriterion("cgcb is null");
            return (Criteria) this;
        }

        public Criteria andCgcbIsNotNull() {
            addCriterion("cgcb is not null");
            return (Criteria) this;
        }

        public Criteria andCgcbEqualTo(String value) {
            addCriterion("cgcb =", value, "cgcb");
            return (Criteria) this;
        }

        public Criteria andCgcbNotEqualTo(String value) {
            addCriterion("cgcb <>", value, "cgcb");
            return (Criteria) this;
        }

        public Criteria andCgcbGreaterThan(String value) {
            addCriterion("cgcb >", value, "cgcb");
            return (Criteria) this;
        }

        public Criteria andCgcbGreaterThanOrEqualTo(String value) {
            addCriterion("cgcb >=", value, "cgcb");
            return (Criteria) this;
        }

        public Criteria andCgcbLessThan(String value) {
            addCriterion("cgcb <", value, "cgcb");
            return (Criteria) this;
        }

        public Criteria andCgcbLessThanOrEqualTo(String value) {
            addCriterion("cgcb <=", value, "cgcb");
            return (Criteria) this;
        }

        public Criteria andCgcbLike(String value) {
            addCriterion("cgcb like", value, "cgcb");
            return (Criteria) this;
        }

        public Criteria andCgcbNotLike(String value) {
            addCriterion("cgcb not like", value, "cgcb");
            return (Criteria) this;
        }

        public Criteria andCgcbIn(List<String> values) {
            addCriterion("cgcb in", values, "cgcb");
            return (Criteria) this;
        }

        public Criteria andCgcbNotIn(List<String> values) {
            addCriterion("cgcb not in", values, "cgcb");
            return (Criteria) this;
        }

        public Criteria andCgcbBetween(String value1, String value2) {
            addCriterion("cgcb between", value1, value2, "cgcb");
            return (Criteria) this;
        }

        public Criteria andCgcbNotBetween(String value1, String value2) {
            addCriterion("cgcb not between", value1, value2, "cgcb");
            return (Criteria) this;
        }

        public Criteria andFobIsNull() {
            addCriterion("FOB is null");
            return (Criteria) this;
        }

        public Criteria andFobIsNotNull() {
            addCriterion("FOB is not null");
            return (Criteria) this;
        }

        public Criteria andFobEqualTo(String value) {
            addCriterion("FOB =", value, "fob");
            return (Criteria) this;
        }

        public Criteria andFobNotEqualTo(String value) {
            addCriterion("FOB <>", value, "fob");
            return (Criteria) this;
        }

        public Criteria andFobGreaterThan(String value) {
            addCriterion("FOB >", value, "fob");
            return (Criteria) this;
        }

        public Criteria andFobGreaterThanOrEqualTo(String value) {
            addCriterion("FOB >=", value, "fob");
            return (Criteria) this;
        }

        public Criteria andFobLessThan(String value) {
            addCriterion("FOB <", value, "fob");
            return (Criteria) this;
        }

        public Criteria andFobLessThanOrEqualTo(String value) {
            addCriterion("FOB <=", value, "fob");
            return (Criteria) this;
        }

        public Criteria andFobLike(String value) {
            addCriterion("FOB like", value, "fob");
            return (Criteria) this;
        }

        public Criteria andFobNotLike(String value) {
            addCriterion("FOB not like", value, "fob");
            return (Criteria) this;
        }

        public Criteria andFobIn(List<String> values) {
            addCriterion("FOB in", values, "fob");
            return (Criteria) this;
        }

        public Criteria andFobNotIn(List<String> values) {
            addCriterion("FOB not in", values, "fob");
            return (Criteria) this;
        }

        public Criteria andFobBetween(String value1, String value2) {
            addCriterion("FOB between", value1, value2, "fob");
            return (Criteria) this;
        }

        public Criteria andFobNotBetween(String value1, String value2) {
            addCriterion("FOB not between", value1, value2, "fob");
            return (Criteria) this;
        }

        public Criteria andWbzcIsNull() {
            addCriterion("wbzc is null");
            return (Criteria) this;
        }

        public Criteria andWbzcIsNotNull() {
            addCriterion("wbzc is not null");
            return (Criteria) this;
        }

        public Criteria andWbzcEqualTo(String value) {
            addCriterion("wbzc =", value, "wbzc");
            return (Criteria) this;
        }

        public Criteria andWbzcNotEqualTo(String value) {
            addCriterion("wbzc <>", value, "wbzc");
            return (Criteria) this;
        }

        public Criteria andWbzcGreaterThan(String value) {
            addCriterion("wbzc >", value, "wbzc");
            return (Criteria) this;
        }

        public Criteria andWbzcGreaterThanOrEqualTo(String value) {
            addCriterion("wbzc >=", value, "wbzc");
            return (Criteria) this;
        }

        public Criteria andWbzcLessThan(String value) {
            addCriterion("wbzc <", value, "wbzc");
            return (Criteria) this;
        }

        public Criteria andWbzcLessThanOrEqualTo(String value) {
            addCriterion("wbzc <=", value, "wbzc");
            return (Criteria) this;
        }

        public Criteria andWbzcLike(String value) {
            addCriterion("wbzc like", value, "wbzc");
            return (Criteria) this;
        }

        public Criteria andWbzcNotLike(String value) {
            addCriterion("wbzc not like", value, "wbzc");
            return (Criteria) this;
        }

        public Criteria andWbzcIn(List<String> values) {
            addCriterion("wbzc in", values, "wbzc");
            return (Criteria) this;
        }

        public Criteria andWbzcNotIn(List<String> values) {
            addCriterion("wbzc not in", values, "wbzc");
            return (Criteria) this;
        }

        public Criteria andWbzcBetween(String value1, String value2) {
            addCriterion("wbzc between", value1, value2, "wbzc");
            return (Criteria) this;
        }

        public Criteria andWbzcNotBetween(String value1, String value2) {
            addCriterion("wbzc not between", value1, value2, "wbzc");
            return (Criteria) this;
        }

        public Criteria andWbzkIsNull() {
            addCriterion("wbzk is null");
            return (Criteria) this;
        }

        public Criteria andWbzkIsNotNull() {
            addCriterion("wbzk is not null");
            return (Criteria) this;
        }

        public Criteria andWbzkEqualTo(String value) {
            addCriterion("wbzk =", value, "wbzk");
            return (Criteria) this;
        }

        public Criteria andWbzkNotEqualTo(String value) {
            addCriterion("wbzk <>", value, "wbzk");
            return (Criteria) this;
        }

        public Criteria andWbzkGreaterThan(String value) {
            addCriterion("wbzk >", value, "wbzk");
            return (Criteria) this;
        }

        public Criteria andWbzkGreaterThanOrEqualTo(String value) {
            addCriterion("wbzk >=", value, "wbzk");
            return (Criteria) this;
        }

        public Criteria andWbzkLessThan(String value) {
            addCriterion("wbzk <", value, "wbzk");
            return (Criteria) this;
        }

        public Criteria andWbzkLessThanOrEqualTo(String value) {
            addCriterion("wbzk <=", value, "wbzk");
            return (Criteria) this;
        }

        public Criteria andWbzkLike(String value) {
            addCriterion("wbzk like", value, "wbzk");
            return (Criteria) this;
        }

        public Criteria andWbzkNotLike(String value) {
            addCriterion("wbzk not like", value, "wbzk");
            return (Criteria) this;
        }

        public Criteria andWbzkIn(List<String> values) {
            addCriterion("wbzk in", values, "wbzk");
            return (Criteria) this;
        }

        public Criteria andWbzkNotIn(List<String> values) {
            addCriterion("wbzk not in", values, "wbzk");
            return (Criteria) this;
        }

        public Criteria andWbzkBetween(String value1, String value2) {
            addCriterion("wbzk between", value1, value2, "wbzk");
            return (Criteria) this;
        }

        public Criteria andWbzkNotBetween(String value1, String value2) {
            addCriterion("wbzk not between", value1, value2, "wbzk");
            return (Criteria) this;
        }

        public Criteria andWbzgIsNull() {
            addCriterion("wbzg is null");
            return (Criteria) this;
        }

        public Criteria andWbzgIsNotNull() {
            addCriterion("wbzg is not null");
            return (Criteria) this;
        }

        public Criteria andWbzgEqualTo(String value) {
            addCriterion("wbzg =", value, "wbzg");
            return (Criteria) this;
        }

        public Criteria andWbzgNotEqualTo(String value) {
            addCriterion("wbzg <>", value, "wbzg");
            return (Criteria) this;
        }

        public Criteria andWbzgGreaterThan(String value) {
            addCriterion("wbzg >", value, "wbzg");
            return (Criteria) this;
        }

        public Criteria andWbzgGreaterThanOrEqualTo(String value) {
            addCriterion("wbzg >=", value, "wbzg");
            return (Criteria) this;
        }

        public Criteria andWbzgLessThan(String value) {
            addCriterion("wbzg <", value, "wbzg");
            return (Criteria) this;
        }

        public Criteria andWbzgLessThanOrEqualTo(String value) {
            addCriterion("wbzg <=", value, "wbzg");
            return (Criteria) this;
        }

        public Criteria andWbzgLike(String value) {
            addCriterion("wbzg like", value, "wbzg");
            return (Criteria) this;
        }

        public Criteria andWbzgNotLike(String value) {
            addCriterion("wbzg not like", value, "wbzg");
            return (Criteria) this;
        }

        public Criteria andWbzgIn(List<String> values) {
            addCriterion("wbzg in", values, "wbzg");
            return (Criteria) this;
        }

        public Criteria andWbzgNotIn(List<String> values) {
            addCriterion("wbzg not in", values, "wbzg");
            return (Criteria) this;
        }

        public Criteria andWbzgBetween(String value1, String value2) {
            addCriterion("wbzg between", value1, value2, "wbzg");
            return (Criteria) this;
        }

        public Criteria andWbzgNotBetween(String value1, String value2) {
            addCriterion("wbzg not between", value1, value2, "wbzg");
            return (Criteria) this;
        }

        public Criteria andWbzccIsNull() {
            addCriterion("wbzcc is null");
            return (Criteria) this;
        }

        public Criteria andWbzccIsNotNull() {
            addCriterion("wbzcc is not null");
            return (Criteria) this;
        }

        public Criteria andWbzccEqualTo(String value) {
            addCriterion("wbzcc =", value, "wbzcc");
            return (Criteria) this;
        }

        public Criteria andWbzccNotEqualTo(String value) {
            addCriterion("wbzcc <>", value, "wbzcc");
            return (Criteria) this;
        }

        public Criteria andWbzccGreaterThan(String value) {
            addCriterion("wbzcc >", value, "wbzcc");
            return (Criteria) this;
        }

        public Criteria andWbzccGreaterThanOrEqualTo(String value) {
            addCriterion("wbzcc >=", value, "wbzcc");
            return (Criteria) this;
        }

        public Criteria andWbzccLessThan(String value) {
            addCriterion("wbzcc <", value, "wbzcc");
            return (Criteria) this;
        }

        public Criteria andWbzccLessThanOrEqualTo(String value) {
            addCriterion("wbzcc <=", value, "wbzcc");
            return (Criteria) this;
        }

        public Criteria andWbzccLike(String value) {
            addCriterion("wbzcc like", value, "wbzcc");
            return (Criteria) this;
        }

        public Criteria andWbzccNotLike(String value) {
            addCriterion("wbzcc not like", value, "wbzcc");
            return (Criteria) this;
        }

        public Criteria andWbzccIn(List<String> values) {
            addCriterion("wbzcc in", values, "wbzcc");
            return (Criteria) this;
        }

        public Criteria andWbzccNotIn(List<String> values) {
            addCriterion("wbzcc not in", values, "wbzcc");
            return (Criteria) this;
        }

        public Criteria andWbzccBetween(String value1, String value2) {
            addCriterion("wbzcc between", value1, value2, "wbzcc");
            return (Criteria) this;
        }

        public Criteria andWbzccNotBetween(String value1, String value2) {
            addCriterion("wbzcc not between", value1, value2, "wbzcc");
            return (Criteria) this;
        }

        public Criteria andWbzslIsNull() {
            addCriterion("wbzsl is null");
            return (Criteria) this;
        }

        public Criteria andWbzslIsNotNull() {
            addCriterion("wbzsl is not null");
            return (Criteria) this;
        }

        public Criteria andWbzslEqualTo(String value) {
            addCriterion("wbzsl =", value, "wbzsl");
            return (Criteria) this;
        }

        public Criteria andWbzslNotEqualTo(String value) {
            addCriterion("wbzsl <>", value, "wbzsl");
            return (Criteria) this;
        }

        public Criteria andWbzslGreaterThan(String value) {
            addCriterion("wbzsl >", value, "wbzsl");
            return (Criteria) this;
        }

        public Criteria andWbzslGreaterThanOrEqualTo(String value) {
            addCriterion("wbzsl >=", value, "wbzsl");
            return (Criteria) this;
        }

        public Criteria andWbzslLessThan(String value) {
            addCriterion("wbzsl <", value, "wbzsl");
            return (Criteria) this;
        }

        public Criteria andWbzslLessThanOrEqualTo(String value) {
            addCriterion("wbzsl <=", value, "wbzsl");
            return (Criteria) this;
        }

        public Criteria andWbzslLike(String value) {
            addCriterion("wbzsl like", value, "wbzsl");
            return (Criteria) this;
        }

        public Criteria andWbzslNotLike(String value) {
            addCriterion("wbzsl not like", value, "wbzsl");
            return (Criteria) this;
        }

        public Criteria andWbzslIn(List<String> values) {
            addCriterion("wbzsl in", values, "wbzsl");
            return (Criteria) this;
        }

        public Criteria andWbzslNotIn(List<String> values) {
            addCriterion("wbzsl not in", values, "wbzsl");
            return (Criteria) this;
        }

        public Criteria andWbzslBetween(String value1, String value2) {
            addCriterion("wbzsl between", value1, value2, "wbzsl");
            return (Criteria) this;
        }

        public Criteria andWbzslNotBetween(String value1, String value2) {
            addCriterion("wbzsl not between", value1, value2, "wbzsl");
            return (Criteria) this;
        }

        public Criteria andTjIsNull() {
            addCriterion("tj is null");
            return (Criteria) this;
        }

        public Criteria andTjIsNotNull() {
            addCriterion("tj is not null");
            return (Criteria) this;
        }

        public Criteria andTjEqualTo(String value) {
            addCriterion("tj =", value, "tj");
            return (Criteria) this;
        }

        public Criteria andTjNotEqualTo(String value) {
            addCriterion("tj <>", value, "tj");
            return (Criteria) this;
        }

        public Criteria andTjGreaterThan(String value) {
            addCriterion("tj >", value, "tj");
            return (Criteria) this;
        }

        public Criteria andTjGreaterThanOrEqualTo(String value) {
            addCriterion("tj >=", value, "tj");
            return (Criteria) this;
        }

        public Criteria andTjLessThan(String value) {
            addCriterion("tj <", value, "tj");
            return (Criteria) this;
        }

        public Criteria andTjLessThanOrEqualTo(String value) {
            addCriterion("tj <=", value, "tj");
            return (Criteria) this;
        }

        public Criteria andTjLike(String value) {
            addCriterion("tj like", value, "tj");
            return (Criteria) this;
        }

        public Criteria andTjNotLike(String value) {
            addCriterion("tj not like", value, "tj");
            return (Criteria) this;
        }

        public Criteria andTjIn(List<String> values) {
            addCriterion("tj in", values, "tj");
            return (Criteria) this;
        }

        public Criteria andTjNotIn(List<String> values) {
            addCriterion("tj not in", values, "tj");
            return (Criteria) this;
        }

        public Criteria andTjBetween(String value1, String value2) {
            addCriterion("tj between", value1, value2, "tj");
            return (Criteria) this;
        }

        public Criteria andTjNotBetween(String value1, String value2) {
            addCriterion("tj not between", value1, value2, "tj");
            return (Criteria) this;
        }

        public Criteria andGysIsNull() {
            addCriterion("gys is null");
            return (Criteria) this;
        }

        public Criteria andGysIsNotNull() {
            addCriterion("gys is not null");
            return (Criteria) this;
        }

        public Criteria andGysEqualTo(String value) {
            addCriterion("gys =", value, "gys");
            return (Criteria) this;
        }

        public Criteria andGysNotEqualTo(String value) {
            addCriterion("gys <>", value, "gys");
            return (Criteria) this;
        }

        public Criteria andGysGreaterThan(String value) {
            addCriterion("gys >", value, "gys");
            return (Criteria) this;
        }

        public Criteria andGysGreaterThanOrEqualTo(String value) {
            addCriterion("gys >=", value, "gys");
            return (Criteria) this;
        }

        public Criteria andGysLessThan(String value) {
            addCriterion("gys <", value, "gys");
            return (Criteria) this;
        }

        public Criteria andGysLessThanOrEqualTo(String value) {
            addCriterion("gys <=", value, "gys");
            return (Criteria) this;
        }

        public Criteria andGysLike(String value) {
            addCriterion("gys like", value, "gys");
            return (Criteria) this;
        }

        public Criteria andGysNotLike(String value) {
            addCriterion("gys not like", value, "gys");
            return (Criteria) this;
        }

        public Criteria andGysIn(List<String> values) {
            addCriterion("gys in", values, "gys");
            return (Criteria) this;
        }

        public Criteria andGysNotIn(List<String> values) {
            addCriterion("gys not in", values, "gys");
            return (Criteria) this;
        }

        public Criteria andGysBetween(String value1, String value2) {
            addCriterion("gys between", value1, value2, "gys");
            return (Criteria) this;
        }

        public Criteria andGysNotBetween(String value1, String value2) {
            addCriterion("gys not between", value1, value2, "gys");
            return (Criteria) this;
        }

        public Criteria andCshhIsNull() {
            addCriterion("cshh is null");
            return (Criteria) this;
        }

        public Criteria andCshhIsNotNull() {
            addCriterion("cshh is not null");
            return (Criteria) this;
        }

        public Criteria andCshhEqualTo(String value) {
            addCriterion("cshh =", value, "cshh");
            return (Criteria) this;
        }

        public Criteria andCshhNotEqualTo(String value) {
            addCriterion("cshh <>", value, "cshh");
            return (Criteria) this;
        }

        public Criteria andCshhGreaterThan(String value) {
            addCriterion("cshh >", value, "cshh");
            return (Criteria) this;
        }

        public Criteria andCshhGreaterThanOrEqualTo(String value) {
            addCriterion("cshh >=", value, "cshh");
            return (Criteria) this;
        }

        public Criteria andCshhLessThan(String value) {
            addCriterion("cshh <", value, "cshh");
            return (Criteria) this;
        }

        public Criteria andCshhLessThanOrEqualTo(String value) {
            addCriterion("cshh <=", value, "cshh");
            return (Criteria) this;
        }

        public Criteria andCshhLike(String value) {
            addCriterion("cshh like", value, "cshh");
            return (Criteria) this;
        }

        public Criteria andCshhNotLike(String value) {
            addCriterion("cshh not like", value, "cshh");
            return (Criteria) this;
        }

        public Criteria andCshhIn(List<String> values) {
            addCriterion("cshh in", values, "cshh");
            return (Criteria) this;
        }

        public Criteria andCshhNotIn(List<String> values) {
            addCriterion("cshh not in", values, "cshh");
            return (Criteria) this;
        }

        public Criteria andCshhBetween(String value1, String value2) {
            addCriterion("cshh between", value1, value2, "cshh");
            return (Criteria) this;
        }

        public Criteria andCshhNotBetween(String value1, String value2) {
            addCriterion("cshh not between", value1, value2, "cshh");
            return (Criteria) this;
        }

        public Criteria andHq40zlIsNull() {
            addCriterion("hq40zl is null");
            return (Criteria) this;
        }

        public Criteria andHq40zlIsNotNull() {
            addCriterion("hq40zl is not null");
            return (Criteria) this;
        }

        public Criteria andHq40zlEqualTo(String value) {
            addCriterion("hq40zl =", value, "hq40zl");
            return (Criteria) this;
        }

        public Criteria andHq40zlNotEqualTo(String value) {
            addCriterion("hq40zl <>", value, "hq40zl");
            return (Criteria) this;
        }

        public Criteria andHq40zlGreaterThan(String value) {
            addCriterion("hq40zl >", value, "hq40zl");
            return (Criteria) this;
        }

        public Criteria andHq40zlGreaterThanOrEqualTo(String value) {
            addCriterion("hq40zl >=", value, "hq40zl");
            return (Criteria) this;
        }

        public Criteria andHq40zlLessThan(String value) {
            addCriterion("hq40zl <", value, "hq40zl");
            return (Criteria) this;
        }

        public Criteria andHq40zlLessThanOrEqualTo(String value) {
            addCriterion("hq40zl <=", value, "hq40zl");
            return (Criteria) this;
        }

        public Criteria andHq40zlLike(String value) {
            addCriterion("hq40zl like", value, "hq40zl");
            return (Criteria) this;
        }

        public Criteria andHq40zlNotLike(String value) {
            addCriterion("hq40zl not like", value, "hq40zl");
            return (Criteria) this;
        }

        public Criteria andHq40zlIn(List<String> values) {
            addCriterion("hq40zl in", values, "hq40zl");
            return (Criteria) this;
        }

        public Criteria andHq40zlNotIn(List<String> values) {
            addCriterion("hq40zl not in", values, "hq40zl");
            return (Criteria) this;
        }

        public Criteria andHq40zlBetween(String value1, String value2) {
            addCriterion("hq40zl between", value1, value2, "hq40zl");
            return (Criteria) this;
        }

        public Criteria andHq40zlNotBetween(String value1, String value2) {
            addCriterion("hq40zl not between", value1, value2, "hq40zl");
            return (Criteria) this;
        }

        public Criteria andGp20IsNull() {
            addCriterion("gp20 is null");
            return (Criteria) this;
        }

        public Criteria andGp20IsNotNull() {
            addCriterion("gp20 is not null");
            return (Criteria) this;
        }

        public Criteria andGp20EqualTo(String value) {
            addCriterion("gp20 =", value, "gp20");
            return (Criteria) this;
        }

        public Criteria andGp20NotEqualTo(String value) {
            addCriterion("gp20 <>", value, "gp20");
            return (Criteria) this;
        }

        public Criteria andGp20GreaterThan(String value) {
            addCriterion("gp20 >", value, "gp20");
            return (Criteria) this;
        }

        public Criteria andGp20GreaterThanOrEqualTo(String value) {
            addCriterion("gp20 >=", value, "gp20");
            return (Criteria) this;
        }

        public Criteria andGp20LessThan(String value) {
            addCriterion("gp20 <", value, "gp20");
            return (Criteria) this;
        }

        public Criteria andGp20LessThanOrEqualTo(String value) {
            addCriterion("gp20 <=", value, "gp20");
            return (Criteria) this;
        }

        public Criteria andGp20Like(String value) {
            addCriterion("gp20 like", value, "gp20");
            return (Criteria) this;
        }

        public Criteria andGp20NotLike(String value) {
            addCriterion("gp20 not like", value, "gp20");
            return (Criteria) this;
        }

        public Criteria andGp20In(List<String> values) {
            addCriterion("gp20 in", values, "gp20");
            return (Criteria) this;
        }

        public Criteria andGp20NotIn(List<String> values) {
            addCriterion("gp20 not in", values, "gp20");
            return (Criteria) this;
        }

        public Criteria andGp20Between(String value1, String value2) {
            addCriterion("gp20 between", value1, value2, "gp20");
            return (Criteria) this;
        }

        public Criteria andGp20NotBetween(String value1, String value2) {
            addCriterion("gp20 not between", value1, value2, "gp20");
            return (Criteria) this;
        }

        public Criteria andGp40IsNull() {
            addCriterion("gp40 is null");
            return (Criteria) this;
        }

        public Criteria andGp40IsNotNull() {
            addCriterion("gp40 is not null");
            return (Criteria) this;
        }

        public Criteria andGp40EqualTo(String value) {
            addCriterion("gp40 =", value, "gp40");
            return (Criteria) this;
        }

        public Criteria andGp40NotEqualTo(String value) {
            addCriterion("gp40 <>", value, "gp40");
            return (Criteria) this;
        }

        public Criteria andGp40GreaterThan(String value) {
            addCriterion("gp40 >", value, "gp40");
            return (Criteria) this;
        }

        public Criteria andGp40GreaterThanOrEqualTo(String value) {
            addCriterion("gp40 >=", value, "gp40");
            return (Criteria) this;
        }

        public Criteria andGp40LessThan(String value) {
            addCriterion("gp40 <", value, "gp40");
            return (Criteria) this;
        }

        public Criteria andGp40LessThanOrEqualTo(String value) {
            addCriterion("gp40 <=", value, "gp40");
            return (Criteria) this;
        }

        public Criteria andGp40Like(String value) {
            addCriterion("gp40 like", value, "gp40");
            return (Criteria) this;
        }

        public Criteria andGp40NotLike(String value) {
            addCriterion("gp40 not like", value, "gp40");
            return (Criteria) this;
        }

        public Criteria andGp40In(List<String> values) {
            addCriterion("gp40 in", values, "gp40");
            return (Criteria) this;
        }

        public Criteria andGp40NotIn(List<String> values) {
            addCriterion("gp40 not in", values, "gp40");
            return (Criteria) this;
        }

        public Criteria andGp40Between(String value1, String value2) {
            addCriterion("gp40 between", value1, value2, "gp40");
            return (Criteria) this;
        }

        public Criteria andGp40NotBetween(String value1, String value2) {
            addCriterion("gp40 not between", value1, value2, "gp40");
            return (Criteria) this;
        }

        public Criteria andLclpxIsNull() {
            addCriterion("lclpx is null");
            return (Criteria) this;
        }

        public Criteria andLclpxIsNotNull() {
            addCriterion("lclpx is not null");
            return (Criteria) this;
        }

        public Criteria andLclpxEqualTo(String value) {
            addCriterion("lclpx =", value, "lclpx");
            return (Criteria) this;
        }

        public Criteria andLclpxNotEqualTo(String value) {
            addCriterion("lclpx <>", value, "lclpx");
            return (Criteria) this;
        }

        public Criteria andLclpxGreaterThan(String value) {
            addCriterion("lclpx >", value, "lclpx");
            return (Criteria) this;
        }

        public Criteria andLclpxGreaterThanOrEqualTo(String value) {
            addCriterion("lclpx >=", value, "lclpx");
            return (Criteria) this;
        }

        public Criteria andLclpxLessThan(String value) {
            addCriterion("lclpx <", value, "lclpx");
            return (Criteria) this;
        }

        public Criteria andLclpxLessThanOrEqualTo(String value) {
            addCriterion("lclpx <=", value, "lclpx");
            return (Criteria) this;
        }

        public Criteria andLclpxLike(String value) {
            addCriterion("lclpx like", value, "lclpx");
            return (Criteria) this;
        }

        public Criteria andLclpxNotLike(String value) {
            addCriterion("lclpx not like", value, "lclpx");
            return (Criteria) this;
        }

        public Criteria andLclpxIn(List<String> values) {
            addCriterion("lclpx in", values, "lclpx");
            return (Criteria) this;
        }

        public Criteria andLclpxNotIn(List<String> values) {
            addCriterion("lclpx not in", values, "lclpx");
            return (Criteria) this;
        }

        public Criteria andLclpxBetween(String value1, String value2) {
            addCriterion("lclpx between", value1, value2, "lclpx");
            return (Criteria) this;
        }

        public Criteria andLclpxNotBetween(String value1, String value2) {
            addCriterion("lclpx not between", value1, value2, "lclpx");
            return (Criteria) this;
        }

        public Criteria andProductCodeIsNull() {
            addCriterion("product_code is null");
            return (Criteria) this;
        }

        public Criteria andProductCodeIsNotNull() {
            addCriterion("product_code is not null");
            return (Criteria) this;
        }

        public Criteria andProductCodeEqualTo(String value) {
            addCriterion("product_code =", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotEqualTo(String value) {
            addCriterion("product_code <>", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeGreaterThan(String value) {
            addCriterion("product_code >", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeGreaterThanOrEqualTo(String value) {
            addCriterion("product_code >=", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeLessThan(String value) {
            addCriterion("product_code <", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeLessThanOrEqualTo(String value) {
            addCriterion("product_code <=", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeLike(String value) {
            addCriterion("product_code like", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotLike(String value) {
            addCriterion("product_code not like", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeIn(List<String> values) {
            addCriterion("product_code in", values, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotIn(List<String> values) {
            addCriterion("product_code not in", values, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeBetween(String value1, String value2) {
            addCriterion("product_code between", value1, value2, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotBetween(String value1, String value2) {
            addCriterion("product_code not between", value1, value2, "productCode");
            return (Criteria) this;
        }

        public Criteria andCgcbwsIsNull() {
            addCriterion("cgcbws is null");
            return (Criteria) this;
        }

        public Criteria andCgcbwsIsNotNull() {
            addCriterion("cgcbws is not null");
            return (Criteria) this;
        }

        public Criteria andCgcbwsEqualTo(String value) {
            addCriterion("cgcbws =", value, "cgcbws");
            return (Criteria) this;
        }

        public Criteria andCgcbwsNotEqualTo(String value) {
            addCriterion("cgcbws <>", value, "cgcbws");
            return (Criteria) this;
        }

        public Criteria andCgcbwsGreaterThan(String value) {
            addCriterion("cgcbws >", value, "cgcbws");
            return (Criteria) this;
        }

        public Criteria andCgcbwsGreaterThanOrEqualTo(String value) {
            addCriterion("cgcbws >=", value, "cgcbws");
            return (Criteria) this;
        }

        public Criteria andCgcbwsLessThan(String value) {
            addCriterion("cgcbws <", value, "cgcbws");
            return (Criteria) this;
        }

        public Criteria andCgcbwsLessThanOrEqualTo(String value) {
            addCriterion("cgcbws <=", value, "cgcbws");
            return (Criteria) this;
        }

        public Criteria andCgcbwsLike(String value) {
            addCriterion("cgcbws like", value, "cgcbws");
            return (Criteria) this;
        }

        public Criteria andCgcbwsNotLike(String value) {
            addCriterion("cgcbws not like", value, "cgcbws");
            return (Criteria) this;
        }

        public Criteria andCgcbwsIn(List<String> values) {
            addCriterion("cgcbws in", values, "cgcbws");
            return (Criteria) this;
        }

        public Criteria andCgcbwsNotIn(List<String> values) {
            addCriterion("cgcbws not in", values, "cgcbws");
            return (Criteria) this;
        }

        public Criteria andCgcbwsBetween(String value1, String value2) {
            addCriterion("cgcbws between", value1, value2, "cgcbws");
            return (Criteria) this;
        }

        public Criteria andCgcbwsNotBetween(String value1, String value2) {
            addCriterion("cgcbws not between", value1, value2, "cgcbws");
            return (Criteria) this;
        }
    }

    /**
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}